SQL之SELECT FROM

SQL之SELECT FROM

１.查看表student中所有的信息。

　SELECT *

　FROM student;

２.查看表student中"name"。

　SELECT name

　FROM student;

３.查看表student中"name","age"。

　SELECT name，age

　FROM student;

４.查看表student中name为Tom的"name","age"。

　SELECT name，age

　FROM student

　WHERE name='Tom';

5.查看表student中name含o的学生的"name","age"。

  SELECT name，age

　FROM student

　WHERE name LIKE '%o%';

6.查看表student中name以m结尾的学生的"name","age"。

  SELECT name，age

FROM student

WHERE name LIKE '%m';

７.查看表student中name以L开头的学生的"name","age"。

  SELECT name，age

FROM student

WHERE name LIKE 'L%';

8.查看表student中id在５－１０之间的学生的"name","age"。

   方法一：SELECT id,name，age FROM student WHERE number BETEEN 5 AND 10;

   方法二：SELECT id,name，age FROM student WHERE number >= 5 AND number